World Indicators Analysis

by Felippe Galdino

Table of Contents

Home Intro Contact About

Dataset source: Kaggle (https://www.kaggle.com/worldbank/world-development-indicators?select=database.sqlite)

1. Exploring the Dataset

1 . Country Table

1.1 Informations of data types and columns for each data set file

CountryCode ShortName TableName LongName Alpha2Code CurrencyUnit SpecialNotes Region IncomeGroup Wb2Code ... GovernmentAccountingConcept ImfDataDisseminationStandard LatestPopulationCensus LatestHouseholdSurvey SourceOfMostRecentIncomeAndExpenditureData VitalRegistrationComplete LatestAgriculturalCensus LatestIndustrialData LatestTradeData LatestWaterWithdrawalData
0 AFG Afghanistan Afghanistan Islamic State of Afghanistan AF Afghan afghani Fiscal year end: March 20; reporting period fo... South Asia Low income AF ... Consolidated central government General Data Dissemination System (GDDS) 1979 Multiple Indicator Cluster Survey (MICS), 2010/11 Integrated household survey (IHS), 2008 NaN 2013/14 NaN 2013.0 2000.0
1 ALB Albania Albania Republic of Albania AL Albanian lek NaN Europe & Central Asia Upper middle income AL ... Budgetary central government General Data Dissemination System (GDDS) 2011 Demographic and Health Survey (DHS), 2008/09 Living Standards Measurement Study Survey (LSM... Yes 2012 2011.0 2013.0 2006.0
2 DZA Algeria Algeria People's Democratic Republic of Algeria DZ Algerian dinar NaN Middle East & North Africa Upper middle income DZ ... Budgetary central government General Data Dissemination System (GDDS) 2008 Multiple Indicator Cluster Survey (MICS), 2012 Integrated household survey (IHS), 1995 NaN NaN 2010.0 2013.0 2001.0
3 ASM American Samoa American Samoa American Samoa AS U.S. dollar NaN East Asia & Pacific Upper middle income AS ... NaN NaN 2010 NaN NaN Yes 2007 NaN NaN NaN
4 ADO Andorra Andorra Principality of Andorra AD Euro NaN Europe & Central Asia High income: nonOECD AD ... NaN NaN 2011. Population data compiled from administra... NaN NaN Yes NaN NaN 2006.0 NaN

5 rows × 31 columns

1.2 Basic Statistics

CountryName CountryCode IndicatorName IndicatorCode Year Value
0 Arab World ARB Adolescent fertility rate (births per 1,000 wo... SP.ADO.TFRT 1960 1.335609e+02
1 Arab World ARB Age dependency ratio (% of working-age populat... SP.POP.DPND 1960 8.779760e+01
2 Arab World ARB Age dependency ratio, old (% of working-age po... SP.POP.DPND.OL 1960 6.634579e+00
3 Arab World ARB Age dependency ratio, young (% of working-age ... SP.POP.DPND.YG 1960 8.102333e+01
4 Arab World ARB Arms exports (SIPRI trend indicator values) MS.MIL.XPRT.KD 1960 3.000000e+06
SeriesCode Topic IndicatorName ShortDefinition LongDefinition UnitOfMeasure Periodicity BasePeriod OtherNotes AggregationMethod LimitationsAndExceptions NotesFromOriginalSource GeneralComments Source StatisticalConceptAndMethodology DevelopmentRelevance RelatedSourceLinks OtherWebLinks RelatedIndicators LicenseType
0 BN.KLT.DINV.CD Economic Policy & Debt: Balance of payments: C... Foreign direct investment, net (BoP, current US$) NaN Foreign direct investment are the net inflows ... NaN Annual NaN NaN NaN NaN NaN Note: Data are based on the sixth edition of t... International Monetary Fund, Balance of Paymen... NaN NaN NaN NaN NaN Open
1 BX.KLT.DINV.WD.GD.ZS Economic Policy & Debt: Balance of payments: C... Foreign direct investment, net inflows (% of GDP) NaN Foreign direct investment are the net inflows ... NaN Annual NaN NaN Weighted average FDI data do not give a complete picture of int... NaN Note: Data starting from 2005 are based on the... International Monetary Fund, International Fin... Data on equity flows are based on balance of p... Private financial flows - equity and debt - ac... NaN NaN NaN Open
2 BX.KLT.DINV.CD.WD Economic Policy & Debt: Balance of payments: C... Foreign direct investment, net inflows (BoP, c... NaN Foreign direct investment refers to direct inv... NaN Annual NaN NaN Sum FDI data do not give a complete picture of int... NaN Note: Data starting from 2005 are based on the... International Monetary Fund, Balance of Paymen... Data on equity flows are based on balance of p... Private financial flows - equity and debt - ac... NaN NaN NaN Open
3 BM.KLT.DINV.GD.ZS Economic Policy & Debt: Balance of payments: C... Foreign direct investment, net outflows (% of ... NaN Foreign direct investment are the net inflows ... NaN Annual NaN NaN Weighted average NaN NaN Note: Data are based on the sixth edition of t... International Monetary Fund, International Fin... NaN NaN NaN NaN NaN Open
4 BN.TRF.KOGT.CD Economic Policy & Debt: Balance of payments: C... Net capital account (BoP, current US$) NaN Net capital account records acquisitions and d... NaN Annual NaN NaN NaN NaN NaN Note: Data are based on the sixth edition of t... International Monetary Fund, Balance of Paymen... NaN NaN NaN NaN NaN Open 
91
array(['Economic Policy & Debt: Balance of payments: Capital & financial account',
       'Economic Policy & Debt: Balance of payments: Current account: Balances',
       'Economic Policy & Debt: Balance of payments: Current account: Goods, services & income',
       'Economic Policy & Debt: Balance of payments: Current account: Transfers',
       'Economic Policy & Debt: Balance of payments: Reserves & other items',
       'Economic Policy & Debt: External debt: Amortization',
       'Economic Policy & Debt: External debt: Arrears, reschedulings, etc.',
       'Economic Policy & Debt: External debt: Commitments',
       'Economic Policy & Debt: External debt: Currency composition',
       'Economic Policy & Debt: External debt: Debt outstanding',
       'Economic Policy & Debt: External debt: Debt ratios & other items',
       'Economic Policy & Debt: External debt: Debt service',
       'Economic Policy & Debt: External debt: Disbursements',
       'Economic Policy & Debt: External debt: Interest',
       'Economic Policy & Debt: External debt: Net flows',
       'Economic Policy & Debt: External debt: Net transfers',
       'Economic Policy & Debt: External debt: Terms',
       'Economic Policy & Debt: External debt: Undisbursed debt',
       'Economic Policy & Debt: National accounts: Adjusted savings & income',
       'Economic Policy & Debt: National accounts: Atlas GNI & GNI per capita',
       'Economic Policy & Debt: National accounts: Growth rates',
       'Economic Policy & Debt: National accounts: Growth rates:',
       'Economic Policy & Debt: National accounts: Local currency at constant prices: Aggregate indicators',
       'Economic Policy & Debt: National accounts: Local currency at constant prices: Expenditure on GDP',
       'Economic Policy & Debt: National accounts: Local currency at constant prices: Other items',
       'Economic Policy & Debt: National accounts: Local currency at constant prices: Value added',
       'Economic Policy & Debt: National accounts: Local currency at current prices: Aggregate indicators',
       'Economic Policy & Debt: National accounts: Local currency at current prices: Expenditure on GDP',
       'Economic Policy & Debt: National accounts: Local currency at current prices: Value added',
       'Economic Policy & Debt: National accounts: Shares of GDP & other',
       'Economic Policy & Debt: National accounts: US$ at constant 2005 prices: Aggregate indicators',
       'Economic Policy & Debt: National accounts: US$ at constant 2005 prices: Expenditure on GDP',
       'Economic Policy & Debt: National accounts: US$ at constant 2005 prices: Value added',
       'Economic Policy & Debt: National accounts: US$ at current prices: Aggregate indicators',
       'Economic Policy & Debt: National accounts: US$ at current prices: Expenditure on GDP',
       'Economic Policy & Debt: National accounts: US$ at current prices: Other items',
       'Economic Policy & Debt: National accounts: US$ at current prices: Value added',
       'Economic Policy & Debt: Official development assistance',
       'Economic Policy & Debt: Purchasing power parity',
       'Education: Efficiency', 'Education: Inputs',
       'Education: Outcomes', 'Education: Participation',
       'Environment: Agricultural production',
       'Environment: Biodiversity & protected areas',
       'Environment: Density & urbanization', 'Environment: Emissions',
       'Environment: Energy production & use', 'Environment: Freshwater',
       'Environment: Land use',
       'Environment: Natural resources contribution to GDP',
       'Financial Sector: Access', 'Financial Sector: Assets',
       'Financial Sector: Capital markets',
       'Financial Sector: Exchange rates & prices',
       'Financial Sector: Interest rates',
       'Financial Sector: Monetary holdings (liabilities)',
       'Health: Disease prevention', 'Health: Health services',
       'Health: Mortality', 'Health: Nutrition',
       'Health: Population: Dynamics', 'Health: Population: Structure',
       'Health: Reproductive health', 'Health: Risk factors',
       'Infrastructure: Communications', 'Infrastructure: Technology',
       'Infrastructure: Transportation', 'Poverty: Income distribution',
       'Poverty: Poverty rates', 'Poverty: Shared prosperity',
       'Private Sector & Trade: Business environment',
       'Private Sector & Trade: Exports',
       'Private Sector & Trade: Imports',
       'Private Sector & Trade: Private infrastructure investment',
       'Private Sector & Trade: Tariffs',
       'Private Sector & Trade: Total merchandise trade',
       'Private Sector & Trade: Trade facilitation',
       'Private Sector & Trade: Trade indexes',
       'Private Sector & Trade: Travel & tourism',
       'Public Sector: Conflict & fragility',
       'Public Sector: Defense & arms trade',
       'Public Sector: Government finance: Deficit & financing',
       'Public Sector: Government finance: Expense',
       'Public Sector: Government finance: Revenue',
       'Public Sector: Policy & institutions',
       'Social Protection & Labor: Economic activity',
       'Social Protection & Labor: Labor force structure',
       'Social Protection & Labor: Migration',
       'Social Protection & Labor: Performance',
       'Social Protection & Labor: Unemployment'], dtype=object)
1344

Introduction

We now can understand that these data are organized mainly by Topic, the ones listed above.

So I will chose one topic for now to do some analysis: 'Social Protection & Labor: Unemployment'

SeriesCode Topic IndicatorName ShortDefinition LongDefinition UnitOfMeasure Periodicity BasePeriod OtherNotes AggregationMethod LimitationsAndExceptions NotesFromOriginalSource GeneralComments Source StatisticalConceptAndMethodology DevelopmentRelevance RelatedSourceLinks OtherWebLinks RelatedIndicators LicenseType
1318 SL.UEM.LTRM.ZS Social Protection & Labor: Unemployment Long-term unemployment (% of total unemployment) NaN Long-term unemployment refers to the number of... NaN Annual NaN NaN Weighted average Data on long-term unemployment are often colle... NaN Relevance to gender indicator: Even though, in... International Labour Organization, Key Indicat... The standard definition of long-term unemploym... While short periods of joblessness are of less... NaN NaN NaN Open
1319 SL.UEM.LTRM.FE.ZS Social Protection & Labor: Unemployment Long-term unemployment, female (% of female un... NaN Long-term unemployment refers to the number of... NaN Annual NaN NaN Weighted average Data on long-term unemployment are often colle... NaN Relevance to gender indicator: Even though, in... International Labour Organization, Key Indicat... The standard definition of long-term unemploym... While short periods of joblessness are of less... NaN NaN NaN Open
1320 SL.UEM.LTRM.MA.ZS Social Protection & Labor: Unemployment Long-term unemployment, male (% of male unempl... NaN Long-term unemployment refers to the number of... NaN Annual NaN NaN Weighted average Data on long-term unemployment are often colle... NaN Relevance to gender indicator: Even though, in... International Labour Organization, Key Indicat... The standard definition of long-term unemploym... While short periods of joblessness are of less... NaN NaN NaN Open
1321 SL.UEM.NEET.FE.ZS Social Protection & Labor: Unemployment Share of youth not in education, employment or... NaN Share of youth not in education, employment or... NaN Annual NaN NaN Weighted average Data should be used cautiously because of diff... NaN When NEET rates are available for more than tw... International Labour Organization, Key Indicat... The standard definition of unemployed persons ... Unemployment and total employment are the broa... NaN NaN NaN Open
1322 SL.UEM.NEET.MA.ZS Social Protection & Labor: Unemployment Share of youth not in education, employment or... NaN Share of youth not in education, employment or... NaN Annual NaN NaN Weighted average Data should be used cautiously because of diff... NaN When NEET rates are available for more than tw... International Labour Organization, Key Indicat... The standard definition of unemployed persons ... Unemployment and total employment are the broa... NaN NaN NaN Open

Filtering the Indicators dataset by Indicators of Unemployment

239
Year Value
count 56035.000000 56035.000000
mean 2001.769448 22.322251
std 7.838904 17.162863
min 1980.000000 0.000000
25% 1996.000000 9.400000
50% 2002.000000 17.200001
75% 2008.000000 31.400000
max 2014.000000 96.699997

At this point, we have a new data set with:

  • 56035 rows;
  • Data since 1980 up to 2014;
  • 239 countries listed
<class 'pandas.core.frame.DataFrame'>
Int64Index: 4020 entries, 1032968 to 5637550
Data columns (total 6 columns):
 #   Column         Non-Null Count  Dtype  
---  ------         --------------  -----  
 0   CountryName    4020 non-null   object 
 1   CountryCode    4020 non-null   object 
 2   IndicatorName  4020 non-null   object 
 3   IndicatorCode  4020 non-null   object 
 4   Year           4020 non-null   int64  
 5   Value          4020 non-null   float64
dtypes: float64(1), int64(1), object(4)
memory usage: 219.8+ KB

21
array(['Long-term unemployment (% of total unemployment)',
       'Long-term unemployment, female (% of female unemployment)',
       'Long-term unemployment, male (% of male unemployment)',
       'Unemployment with primary education (% of total unemployment)',
       'Unemployment with primary education, female (% of female unemployment)',
       'Unemployment with primary education, male (% of male unemployment)',
       'Unemployment with secondary education (% of total unemployment)',
       'Unemployment with secondary education, female (% of female unemployment)',
       'Unemployment with secondary education, male (% of male unemployment)',
       'Unemployment with tertiary education (% of total unemployment)',
       'Unemployment with tertiary education, female (% of female unemployment)',
       'Unemployment with tertiary education, male (% of male unemployment)',
       'Unemployment, female (% of female labor force) (national estimate)',
       'Unemployment, male (% of male labor force) (national estimate)',
       'Unemployment, total (% of total labor force) (national estimate)',
       'Unemployment, youth female (% of female labor force ages 15-24) (national estimate)',
       'Unemployment, youth male (% of male labor force ages 15-24) (national estimate)',
       'Unemployment, youth total (% of total labor force ages 15-24) (national estimate)',
       'Unemployment, youth female (% of female labor force ages 15-24) (modeled ILO estimate)',
       'Unemployment, youth male (% of male labor force ages 15-24) (modeled ILO estimate)',
       'Unemployment, youth total (% of total labor force ages 15-24) (modeled ILO estimate)'],
      dtype=object)
Text(0.5, 1.0, 'Unemployment in G7 Countries - 1980 to 2014')
CountryName CountryCode IndicatorName IndicatorCode Year Value
1054337 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1980 17.000000
1137476 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1981 17.700001
1222204 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1982 19.200001
1307476 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1983 8.600000
1393052 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1984 9.400000
1479610 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1985 9.400000
1567354 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1986 10.600000
1656137 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1987 10.700000
1745295 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1988 11.000000
1836491 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1989 11.000000
1941656 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1990 9.800000
2058632 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1991 10.100000
2176839 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1992 9.300000
2299889 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1993 10.200000
2424658 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1994 11.100000
2554837 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1995 11.700000
2689960 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1996 11.900000
2825340 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1997 12.000000
2962240 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1998 12.100000
3101812 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 1999 11.700000
3250589 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2000 10.800000
3402710 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2001 9.600000
3555396 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2002 9.200000
3709646 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2003 8.900000
3865278 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2004 7.900000
4035371 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2005 7.700000
4213714 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2006 6.800000
4392669 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2007 6.100000
4572903 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2008 6.700000
4751946 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2009 7.700000
4934984 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2010 8.400000
5116392 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2011 8.400000
5291971 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2012 10.700000
5457559 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2013 12.100000
5588570 Italy ITA Unemployment, total (% of total labor force) (... SL.UEM.TOTL.NE.ZS 2014 12.700000

eda

Found: ecCodes v2.22.1.
Your system is ready.

[NbConvertApp] Converting notebook World_Population.ipynb to html
[NbConvertApp] Writing 9652383 bytes to World_Population.html
GlyphRenderer(
id = '1038', …)
Loading BokehJS ... 
[NbConvertApp] Converting notebook World_Population.ipynb to html
[NbConvertApp] Writing 14419929 bytes to World_Population.html